SUPPORT / SAMPLES & SAS NOTES
Problem Note 45261: Publishing to the Common Data Model triggers the error "Variable Consolidation_Flag has been defined as both character and numeric"
 |  |  |  |
The SAS® Stored Process Server writes the following error to its log when you migrate from SAS® Marketing Automation 5.1 to 5.3 or 5.4, and then publish to the Common Data Model:
ERROR: Variable Consolidation_Flag has been defined as both character and numeric.
This problem happens because the User-Defined Fields in the Common Data Model extension table have data type character in 5.1, but have data type binary numeric in newer versions.
To work around this problem, manually correct the data types for User-Defined Fields in the CI_CAMPAIGN_EXT table in your Common Data Model database.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Marketing Automation | Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Windows Vista | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| HP-UX IPF | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||
| Linux | 5.1 | 5.41 | 9.1 TS1M3 SP4 | 9.3 TS1M0 | ||